Need value for spread sheet

R

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.
 
G

Gord Dibben

Just an added item of terminology.

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


Gord Dibben MS Excel MVP
 
Top