Forum Discussion
erin-5304
Nov 29, 2022Copper Contributor
Multiple IF Formula
I am trying to write a formula for the following situation:
If C49 has a Y then calculate 225+(I49*0.2):
- If the answer is not greater than 750 then the cell should fill with 750.
- If it is more than 750 it needs to be whatever the answer is.
- If there isn't a N in C49, the cell should be blank.
Here is the formula I am trying that isn't working...Help Please!!
=IF(C49="Y",IF((225+(I49*0.2)>750,225+(I49*0.2),750,"")
=IF(C49<>"Y","",IF(AND(C49="Y",225+(I49*0.2)>750),225+(I49*0.2),750))
You can try this formula.
3 Replies
Sort By
- OliverScheurichGold Contributor
=IF(C49<>"Y","",IF(AND(C49="Y",225+(I49*0.2)>750),225+(I49*0.2),750))
You can try this formula.
- erin-5304Copper ContributorYour formula worked perfectly 🙂 Thanks so much for your help!
- OliverScheurichGold ContributorYou are welcome.