| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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!!! |
|
#2
|
|||
|
|||
|
=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!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need a formula to determine the greater of a or b... | Excel Discussion (Misc queries) | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
| How to make a formula display results only if value is greater tha | Excel Discussion (Misc queries) | |||
| Help with macro formula and variable | Excel Worksheet Functions | |||
| If Greater than when a formula Results in N/A | Excel Worksheet Functions | |||
Linear Mode
