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