=IF(SUM(A1:C1)500,0.95,1.25)
--
Regards,
Peo Sjoblom
"Debbie" wrote in message
...
I am trying to create a spreadsheet and I need the following formula.
Nothing that I try works.
Basically it needs to work like this - If the total of Column 1A + 1B +
1C
is GREATER than 500.00 enter .95. If the total of all three columns is
LESS
than 500.00 enter $1.25
Can someone help me, please.
Thanks!!!
|