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"))

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"))

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"))