| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Basic IF function help
i am new to excel and trying to use the IF function. i am trying to
figure out how to get excel to only display the result of the formula is a number. in some cases, the formula has "0" in numerator so i get "Div/0" answer. in that case, i want the result to display just a blank. any help will be appreciated. thanks. my current formula is =IF((4*R3/G2)xxxxxx,(4*R3/G2),("N/A")) |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Basic IF function help
One way:
=IF(G2=0,"",IF(4*R3/G2)xxxxx,4*R3/G2,"N/A")) In article .com, "gtd068a" wrote: i am new to excel and trying to use the IF function. i am trying to figure out how to get excel to only display the result of the formula is a number. in some cases, the formula has "0" in numerator so i get "Div/0" answer. in that case, i want the result to display just a blank. any help will be appreciated. thanks. my current formula is =IF((4*R3/G2)xxxxxx,(4*R3/G2),("N/A")) |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Basic IF function help
Thank you!
I have it working now! JE McGimpsey wrote: One way: =IF(G2=0,"",IF(4*R3/G2)xxxxx,4*R3/G2,"N/A")) In article .com, "gtd068a" wrote: i am new to excel and trying to use the IF function. i am trying to figure out how to get excel to only display the result of the formula is a number. in some cases, the formula has "0" in numerator so i get "Div/0" answer. in that case, i want the result to display just a blank. any help will be appreciated. thanks. my current formula is =IF((4*R3/G2)xxxxxx,(4*R3/G2),("N/A")) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom Function basic | Excel Worksheet Functions | |||
| VBA | Excel Worksheet Functions | |||
| Date & Time | New Users to Excel | |||
| Need a ISWorkday Function -- Any Ideas | Excel Worksheet Functions | |||
| HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Linear Mode
