=IF(H3+I3=2,"$30", IF(H3+I3=3, "$60"), IF(H3+I3=4, "$100"))
How can I make this work?
=IF(H3+I3=2,"$30", IF(H3+I3=3, "$60"), IF(H3+I3=4, "$100"))
How can I make this work?
IF way:
Formula:=IF(H3+I3=2,30,IF(H3+I3=3, 60, IF(H3+I3=4, $100"))
Some other way
Formula:=CHOOSE(H3+I3, "?", 30, 60, 100)
Format cell as currency ($)
Awesome, thank you for the fast reply. This is my new favorite forum!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks