Multiple Criteria

[Tmoske]

I'm trying to make a formula that will calculate with two criteria.
It keeps giving me an error.

=if(A1=90,B1+C1,"0"),(A1>90,B1+D1,"0")

Thanks for any assistance,
Tmoske

 

[mjrofra]

Hi,

maybe you want to nest another if condition, like this:

=IF(A1=90,B1+C1,IF(A1>90,B1+D1,0))

 

[Tmoske]

Thanks,
That is a simple solution. Works just the way I need it.

Thanks so much,
Tmoske