formula a value in a formula

  • Thread starter Thread starter Richard
  • Start date Start date
R

Richard

The formula below will produce a value that is greater than 6 in my
spreadsheet. However, I want to add another condition to this formula to
minus .5 ofF the value anytime the formula produce a value greater than 6.
Is this possible?

=IF((OR(TIME!I11="",TIME!G11="")),0,IF((TIME!I11<TIME!G11),((TIME!I11-TIME!G11)*24)+24,(TIME!I11-TIME!G11)*24))
 
Yes. Let X be your formula w/o the 1st =.
Then =IF(X>6, X-0.5,X) will do what you want.

Hth,
Merjet
 
Back
Top