Column A, B, and C may or may not be populated. When they are, it is always a $ amount and always populated in sequence. First A is populated, then at a later date B is populated, then at a later date, C is populated.



I need a formula in column D that checks each column to see if it is populated and return a calculated amount based on the most recently updated field, starting with column C:

If C is populated, D should return the $ amount in C *.88.

If C is not populated, look in column B, and if it is populated, return the amount in B *.88.

If neither B nor C is populated, look in column A and if it is populated, return the amount in column A*.88.

If none of them are populated, D should return "".

This is my first stab at it and get a "too many arguments" error.

=IF(ISNUMBER([@[12-Month Lock-in Amount]]),( [@[12-Month Lock-in Amount]]*.88), IF(ISNUMBER([@[6-Month Estimate]]),([@[6-Month Estimate]]*.88), IF(ISNUMBER([@[30-Day Estimate]]),([@[30-Day Estimate]]*.88)),””))

Thanks.

Perhaps at the end of the formula

...([@[30-Day Estimate]]*.88),””)))
and only ONE closing ) after the last .88 ?


BTW you seem to be using O365? Could you add that info to your signature ( with the version) please? ( the forum does not allow XL versions higher than 2021 as there are many versions of 365). Thx

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

In C2,

=BYROW(A2:C7,LAMBDA(x,IFERROR(88*INDEX(x,AGGREGATE (14,6,COLUMN(x)/(x>0),1)),"")))

Or

=MAP(A2:A7,B2:B7,C2:C7,LAMBDA(x,y,z,IF(z>0,88*z,IF (y>0,88*y,IF(x>0,88*x,"")))))

For other versions in C2 copied down

=IFERROR(88*@INDEX($A2:$C2,AGGREGATE(14,6,COLUMN($ A2:$C2)/($A2:$C2>0),1)),"")

Why do things easily when doing them the hard way also works?

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

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, "")))

Happy to see I was on the right track

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post