In Column A some times I will have a number, text or it will be blank. I am using this formula "=IF(A30>0.5,(G30/E30),IF(A30=Text,0))" to get the value when column G is divided by column E without getting error. Can you please help me out on this. Thanks for taking a look at it.
Roco
not sure what happens when its blank?
Formula:
Please Login or Register to view this content.
anyway
see formula
checks for blank first
then checks for text
then checks what the value of a30 is
not sure what you want when its less than 0.5
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Try
=IF(AND(ISNUMBER(A30),A30>0.5),G30/E30,0)
Thanks for the help on that. Works great.
You're welcome
Here's another one...
=IF(N(A30)>0.5,G30/E30,0)
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks