I'm new to this board and hope I can find the help I need to solve some basic problems I have with understanding Excel.
I'm working on a project comparing proposed cost vs current cost. I would like to enter a logic formula as follows.
If the units in a column are less than 100 the rate of $193.00 would display. If the units are between 100-300 than a rate of 194.00 would display. This same logic would follow for 300-500, 500-700 and over 700 units with increasing rate allpying to each level.
Any help would be appreciated.
I'm working on a project comparing proposed cost vs current cost. I would like to enter a logic formula as follows.
If the units in a column are less than 100 the rate of $193.00 would display. If the units are between 100-300 than a rate of 194.00 would display. This same logic would follow for 300-500, 500-700 and over 700 units with increasing rate allpying to each level.
Any help would be appreciated.