View Single Post
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

=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!!!