View Single Post
 
Old 09-03-2024, 07:25 AM
wsnow wsnow is offline Windows 11 Office 2021
Novice
 
Join Date: Sep 2023
Posts: 24
wsnow is on a distinguished road
Default

Turns out I had unneeded ) after each instance of .88, but needed one additional one at the very end. A co-worker spotted the error.
=IF(ISNUMBER([@[12-Month Lock-in Amount]]), [@[12-Month Lock-in Amount]]*0.88, IF(ISNUMBER([@[6-Month Estimate]]),[@[6-Month Estimate]]*0.88, IF(ISNUMBER([@[30-Day Estimate]]),[@[30-Day Estimate]]*0.88, "")))
Reply With Quote