Combining multiple Statements Into One Formula

[hyewiz]

Hi there I'm working on excel template where
column E formula would be
=IFS(F8<$Q$3,F8*$P$3*$O$3,AND(F8>$Q$3,F8<$Q$4),F8*$P$3*$O$4,F8>$Q$4,F8*$P$3*$O$5)


this is working fine, but when column F is blank it shows #VALUE !, how can fix this to show blank.


also is there a way we can update this formula so it checks column G also and if there is a value then to us same formula but minus the P3


so basically I like column E gets his value from columns F & G if there is value and to use the formula according.

I hope this makes sense to the reader, sorry if I'm confusing you.


Thank you

 

[Eric W]

How about:

=IFERROR(IF(F8<$Q$3,$O$3,IF(F8<$Q$4,$O$4,$O$5))*F8*IF(G8<>"",1,$P$3),"")

 

[hyewiz]

Thank you very much