| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula doesn't compute. Can you figure it out?
I have this formula at the end of a row in column J.
=IF(AND(E12<"B",E12<"S"),"",IF(E12="B",G12-F12,F12-G12)/IF(C12="JPY",100,1) It says that if Cell E12 is anything other than "B" or "S" than leav this cell Blank, otherwise do this formul IF(E12="B",G12-F12,F12-G12)/IF(C12="JPY",100,1) The cell is not blank and it contains #VALUE instead. How do I get rid of #VALUE and leave the cell blank unless data i entered into the cells defined in the formula -- Message posted from http://www.ExcelForum.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to Compute Overtime hours | Excel Worksheet Functions | |||
| Formula to compute someone's age if you enter their B-day | Excel Discussion (Misc queries) | |||
| Formula Saves In Cell But Does Not Compute | Excel Worksheet Functions | |||
| Formula won't compute | Excel Discussion (Misc queries) | |||
| How to make excel not to compute formula | Excel Worksheet Functions | |||
![Jetheat[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
