Forum Discussion
Solved
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 i...
=IF(C49<>"Y","",IF(AND(C49="Y",225+(I49*0.2)>750),225+(I49*0.2),750))
You can try this formula.
=IF(C49<>"Y","",IF(AND(C49="Y",225+(I49*0.2)>750),225+(I49*0.2),750))
You can try this formula.
- Your formula worked perfectly 🙂 Thanks so much for your help!
- You are welcome.
