how do I nest 3 items?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello, wondering if someone can help me please?
I have a cell that I want to reference to and dependant and what it
contains, I would like it to display one of 2 returns. The formulae goes into
w5. The reference cell is v5.

If V5 is less than or equal to 8% show contents of cell v5
If V5 is greater than 8% then show "REVIEW % too high"

=IF V5<=8%,V5,IF V5>8%,"REVIEW % too high"

What am I doing wrong? I also want it to be blank if cell v5 is blank.
Thanks in advance
B
 
Back
Top