| Home |
| Search |
| Today's Posts |
|
#10
|
|||
|
|||
neater!
KL "Bob Phillips" wrote in message ... or MAX(B20-7,5,0) -- HTH Bob Phillips "KL" wrote in message ... Hi PK, Try typing the following formula in [B21]: =(B20-7.50)*(B20-7.5) or =IF(B20-7.50,B20-7.5,0) Regards, KL "PK" wrote in message ... Hi, I need to compare a value in a cell and see if it is higher than 7.5. If it is higher than 7.5 I want to subract 7.5 from it and move the result into another cell. For instance. If B20 7.5 Subract 7.5 from B20 and Move to B21. How can I do that easily? I was trying to use the IF function but cannot find the correct formatting to get it to move the value to the B21 cell. Thanks, PK |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| AutoFIll -by dragging the bottom-right corner of the cell | Excel Discussion (Misc queries) | |||
| how to create a variable column in cell reference | Excel Worksheet Functions | |||
| Can a Formula in Cell X modify Cell Y? | Excel Discussion (Misc queries) | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
| VLookup resulting in a blank cell... | Excel Worksheet Functions | |||
Threaded Mode
