So I have three different forms of travel and a If function associated with them. I need help writing this out. I got it to come out the #VALUE!. Is there something wrong with my formula or am I just going about this all wrong?
Function:=IF(H4=1," Yep", IF(H4=2,"no", IF(H4=3,"wee"))), IF("Yep"=Q4<=35,” urgent”,” normal”),IF("no"=Q4<=25,” urgent”,” normal”),IF("wee"=Q4<=10,” urgent”,” normal”)
Bookmarks