Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional IF function help ??
Hi - I am hoping someone can help me with my If statement. I need it to do
divide Column N by Column L if Column 0 Here's what I tried but it's not working =IF(N6290,IF(ISERR(N629/L629),"",(N629/L629))) Thank you ;) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional IF function help ??
Try it like this:
=IF(N6290,IF(ISERR(N629/L629),"",N629/L629),"") Hope this helps. Pete On Aug 3, 4:20*pm, H wrote: Hi - I am hoping someone can help me with my If statement. *I need it to do divide Column N by Column L if Column 0 Here's what I tried but it's not working =IF(N6290,IF(ISERR(N629/L629),"",(N629/L629))) Thank you ;) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional IF function help ??
Thank you - works perfectly ;)
"Pete_UK" wrote: Try it like this: =IF(N6290,IF(ISERR(N629/L629),"",N629/L629),"") Hope this helps. Pete On Aug 3, 4:20 pm, H wrote: Hi - I am hoping someone can help me with my If statement. I need it to do divide Column N by Column L if Column 0 Here's what I tried but it's not working =IF(N6290,IF(ISERR(N629/L629),"",(N629/L629))) Thank you ;) |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional IF function help ??
You're welcome - thanks for feeding back.
Pete On Aug 3, 4:39*pm, H wrote: Thank you - works perfectly ;) "Pete_UK" wrote: Try it like this: =IF(N6290,IF(ISERR(N629/L629),"",N629/L629),"") Hope this helps. Pete On Aug 3, 4:20 pm, H wrote: Hi - I am hoping someone can help me with my If statement. *I need it to do divide Column N by Column L if Column 0 Here's what I tried but it's not working =IF(N6290,IF(ISERR(N629/L629),"",(N629/L629))) Thank you ;)- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Function | Excel Worksheet Functions | |||
Conditional Function | Excel Worksheet Functions | |||
Conditional function | Excel Worksheet Functions | |||
conditional MIN() function | Excel Worksheet Functions | |||
The conditional format function | Excel Worksheet Functions |