Need value for spread sheet

[rreuille]

Hi
I am pretty new at using the excel spreadsheet and need help setting
up a formula. I am setting up a drivers log and the formula I'm
trying to get is this

If G28+G29 >=34 then 70 is the output numer, if G28+G29 <34 then the
output would be F26-B27.

This would all be in the same box. I have tried the countif, sumif,
sumproduct functions and I know it's probably just a matter of not
having a comma or parentesis in the right place, but I'm going crazy
and need help.

 

[Guest]

=IF((G28+G29)>=34,70,F26-B27)

 

[Gord Dibben]

Just an added item of terminology.

This formula is entered into a "cell", not a "box".


Gord Dibben MS Excel MVP