Basic IF function help

G

gtd068a

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Newbie Help - IF Yes No Function 0
Drop down list control value in vba 2
Would like to input 3 letters into a cell, each having a different numerical value 5
Need help with a formula 3
hyperlink to cell based on formula results 5
List all tables, including document structure 0
Using if and and for an email tracker 3
Vlookup to return 0 instead of NA 1

Top