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
Flipkart return comments - Guide
Agp function - Guide
If cell contains date then return value ✓ - Excel Forum
Excel "IF" function w/ date in test cell ✓ - Excel Forum
If cell contains specific text then return value in another cell ✓ - Excel Forum

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

help me to add particular cells

Excel - IF function with multiple words

If cell = date return yes or no.

WOW equipment return

Excel function question

Similar discussions

Subscribe To Our Newsletter!