ExcelBanter - If Satement Modification

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - If Satement Modification (https://www.excelbanter.com/excel-programming/305225-if-satement-modification.html)

If Satement Modification

Thanx for the help on my first posting but after looking
at how it works in the sheet and it works great, I have
been asked to modify this code a little

IF(L75="","Global Trade SV","") ....to say

IF H75 and L75 are blank, then leave O75 blank. else If
just L75 is blank then O75 is equal to Global Trade SV.

Thanx again

Frank Kabel

If Satement Modification

Hi
IF(AND(H75="",L75=""),"",IF(L75="","Global Trade SV",""))

--
Regards
Frank Kabel
Frankfurt, Germany

DM wrote:
Thanx for the help on my first posting but after looking
at how it works in the sheet and it works great, I have
been asked to modify this code a little

IF(L75="","Global Trade SV","") ....to say

IF H75 and L75 are blank, then leave O75 blank. else If
just L75 is blank then O75 is equal to Global Trade SV.

Thanx again

All times are GMT +1. The time now is 11:57 AM.