Excel formula question

  • Thread starter Thread starter Nocturnal
  • Start date Start date
N

Nocturnal

I have a cell and formula as follows:

=IF(C3="Premium",152.00,0.00)

However, I want it to be if C3="Premium" then 152.00 OR if C3="Advance" then
107.00.

How would I achieve this?
 
=IF(C3="Premium",152,IF*C3="Advance",107,0))

You don't need to put any trailing zeroes after the decimal point, that is
done by the format.
 
Or maybe.........

=IF(C3="Premium",152,IF(C3="Advance",107,0))


Vaya con Dios,
Chuck, CABGx3
 
Back
Top