View Single Post
  #1   Report Post  
Debbie
 
Posts: n/a
Default Less than, Greater than Formula

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