greater to or less than formula

  • Thread starter Thread starter cbm
  • Start date Start date
C

cbm

I'd like to try two formulas, they read as follows:

IF F23 IS LESS THAN OR EQUAL TO 30 THEN ((F23*F23)*0.785), IF F23 I
MORE THAN 30 THEN ((F23*F23)*-0.335)+(F23*69.3)-1087)

the second is:

IF 23 IS $5000 OR MORE THEN ROUND TO THE NEAREST $100, IF S23 IS LES
THAN $5000 THEN ROUND TO THE NEAREST $10

Thanks in advance, chris miller
(e-mail address removed)
 
OK, try these then:

=IF(F23<=30,F23*F23*0.785,((F23*F23)*-0.335)+(F23*69.3)-1087)

and:

=IF(S23>=5000,ROUND(S23,-2),ROUND(S23,-1))

Hope this helps.

Pete
 
Back
Top