Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Good afternoon,
I have been attempting to create a formula to do the following: In three columns: B, C & H. If B3 & C3 do not contain a value I want to H3 to also be blank despite H2 containing a figure. However, if B2 and or C2 contain a figure, I wish to display the result - if this makes sense! The existing formula in H3 is: =H2+C3-B3 and I've been trying to create the appropriate formula without success. What am I doing wrong? Regards Peter |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Nested If problem | Excel Worksheet Functions | |||
Nested If problem | Excel Worksheet Functions | |||
A problem with Nested IFs | Excel Worksheet Functions | |||
Nested IF problem | Excel Discussion (Misc queries) | |||
Nested if problem | Excel Worksheet Functions |