Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have an if statement that says =if(ISBLANK(C3:F3),ROUNDUP(B3,0),b3+.01)
First off, the statement does not seem to evaluate the "roundup" part, meaning that the statement is backwards. What I am trying to accomplish is that if c3:f3 are blank, then I want the number in b3 to be added to .01. If there is a character in c3:f3, then I want the number in b3 to be rounded up to the next whole number and the answer reflected in g3. If I were to do the formula as is, and left the row blank then it would add ..01 to b3, but if later I wanted to change the outcome and put a character into c3:f3, shouldn't the answer automatically round b3 to the next whole number or would I have to re-write the formula. -- Sierra |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IF statement inside a SUMIF statement.... or alternative method | Excel Worksheet Functions | |||
Reconcile Bank statement & Credit card statement & accounting data | Excel Worksheet Functions | |||
Embedding an OR statement in an IF statement efficiently | Excel Discussion (Misc queries) | |||
appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
Help please, IF statement/SUMIF statement | Excel Worksheet Functions |