Try this:

=IF(V5="","",IF(V5<=8%,V5,"REVIEW % too high"))

HTH,
Elkar


"Bee" wrote:

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