If on an If

L

litm

I have added an if statement under X5 so that if another cell had avalue then
it wold show here. I have then written anoher if statement under X5 points
=IF(V3>0,11,""). This should not return 11 in this example as X5 does not
have a value, the cell just has =IF(E3>0,E3,"")

How do I get the X5points to return nil.
X5 X9 X12 VT7 Other X5 Points X9 points X12
2200 11 17 17 12
 
E

Eduardo

Hi,
The problem with your formula was a "," instead of "." after the 0, try

=IF(V3>0.11,"")

if this helps please click yes, thanks
 

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

Standard Error Formula 1
Count values only if matches and return on another worksheet 3
time_report_date-wise_employee-wise 6
*Issue* Concatenate dates in a large range of cells in a row. 5
Formula 6
Modifying a complex date formual to count months 4
Date value content format 0
check data from different cells 1

Top