Capsaicin Burn
New Member
- Joined
- Jan 26, 2018
- Messages
- 38
I need to determine if a cell is greater than a number then perform one calculation and if its great then perform a another calculation.
Example:
If A1 is less than or equal to 500 then subtract 200 and multiply it by 10% or .10
If A1 is greater than 500 then subtract 250 and multiply it by 12% or .12
All of my google searches are to vague to help he with this. Most of what I find tells me how to display text based on cell values.
As always, any help is greatly appreciated.
Jim
Example:
If A1 is less than or equal to 500 then subtract 200 and multiply it by 10% or .10
If A1 is greater than 500 then subtract 250 and multiply it by 12% or .12
All of my google searches are to vague to help he with this. Most of what I find tells me how to display text based on cell values.
As always, any help is greatly appreciated.
Jim