View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bee Bee is offline
external usenet poster
 
Posts: 46
Default how do I nest 3 items?

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 V58%,"REVIEW % too high"

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