Stop the #Value! error showing

  • Thread starter Thread starter Bob Vance
  • Start date Start date
B

Bob Vance

--
=IF(OR(AV92="",AV92=0),"",AZ92*AV92*1.125)
In this formula can I add something to this so as if there is something in
AV92 but nothing in AZ92 I wont get a #VALUE! error


Thanks in advance.........Bob Vance
 
Bob,

I don't think you should be getting an error when AZ92 is empty. Perhaps it
has spaces, or other stuff. Try =LEN(AZ92) in a cell. Same with AV92.
 
AV92 has this formula :
=IF(OR(AT92="",AT92=0,AU92="",AU92=0),"",AU92-AT92+1)
AT92=
=IF(ISNA(VLOOKUP(AW92,DAILY_CHARGES,4,0)),"",VLOOKUP(AW92,DAILY_CHARGES,4,0)
)
BA92 that is getting the #Value! has this formula:
=IF(OR(AV92="",AV92=0),"",AZ92*AV92*1.125)
Thanks...Bob
 
Back
Top