IF Function return FALSE

Closed

drbram2379 Posts 1 Registration date Tuesday July 8, 2014 Status Member Last seen July 8, 2014 - Jul 8, 2014 at 09:52 PM
Osama_bb11 Posts 21 Registration date Sunday May 25, 2014 Status Member Last seen September 25, 2014 - Jul 9, 2014 at 01:09 AM

Hello anyone,

I need help on my formula. I use an IF formula but if the cell shown zero it returns false.
the formula is like this
=if(L7=0,0,if(L7<99.5,0,if(L7<109.5,2,if(L7<309.5,3,))))
the L7 itself contains formula
=if(k7=0,"",k7/g7*100)
k7 is sum from i7 to j7
=sum (i7:j7)
g7 is the target point the formula has to achieved to get 100%.
any help will higly appreciated.
thank u

IF Function return FALSE
Find function on mac - Guide
Zuma return - Download - Puzzle
If cell contains date then return value ✓ - Excel Forum
Excel formula to check if cell contains a date - Excel Forum
Accessor function c++ - Guide

1 response

Answer 1 / 1

Osama_bb11 Posts 21 Registration date Sunday May 25, 2014 Status Member Last seen September 25, 2014
Jul 9, 2014 at 01:09 AM

Hi

there two points :

=if(L7=0,0,if(L7<99.5,0,if(L7<109.5,2,if(L7<309.5,3,"put something here"))))

where (what cell) this formula located

Similar discussions

WOW equipment return

help me to add particular cells

If a cell contains any text then add a value

If cell = date return yes or no.

Excel: If Date =, then enter a value

Similar discussions

Subscribe To Our Newsletter!