Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Isserror question
=IF(iserror(B5+1$B$3+$B$2,"",B5+1),"",(B5+1$B$3+ $B$2,"",B5+1))
Excel keeps saying there is a problem with the first double quotes... Help please? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Isserror question
What exactly are you trying to do?
ISERROR() takes one argument. IF() takes three. As a wild guess: =IF(ISERROR(B5+1$B$3+$B$2), "", B5+1) In article , "Brad" wrote: =IF(iserror(B5+1$B$3+$B$2,"",B5+1),"",(B5+1$B$3+ $B$2,"",B5+1)) Excel keeps saying there is a problem with the first double quotes... Help please? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|