Need value for spread sheet
 

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.

Need value for spread sheet
 

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


" wrote:

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.

Need value for spread sheet
 

Just an added item of terminology.

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


Gord Dibben MS Excel MVP

On Sat, 28 Apr 2007 13:44:01 -0700, Teethless mama
wrote:

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


" wrote:

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.