Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Simple If-Then Formula
I am trying to set up a simple if-then formula. I want three possible
outcomes. Here's the deal: I want a formula that will do the following: If F2 is greater than $50.00 but less than $500.00, the value for G2 should be $25.00. If F2 is greater than or equal to $500.00, the value for G2 should be $50.00. If F2 is less than $50.00, the value for G2 should be 0. Please help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
simple interest formula in excel | Excel Discussion (Misc queries) | |||
Help - Simple Formula ! | Excel Discussion (Misc queries) | |||
Simple formula help | Excel Worksheet Functions | |||
help with simple formula | Excel Worksheet Functions | |||
Excel Miscalculates simple formula..Help!! | Excel Worksheet Functions |