I have a two cells,
C14 that is blank until i enter a value between 180 and 1
in D14 i want to return the value of $22 if c14 has the above value range
and remain blank if C14 is blank.
I have done something like this with other fields, but only if I was adding or subtracting values such as below.
=IF(D14="","",E14-D14)
is there a way i can do this?
and thanks for any help
C14 that is blank until i enter a value between 180 and 1
in D14 i want to return the value of $22 if c14 has the above value range
and remain blank if C14 is blank.
I have done something like this with other fields, but only if I was adding or subtracting values such as below.
=IF(D14="","",E14-D14)
is there a way i can do this?
and thanks for any help
