Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If Satement formula | Excel Worksheet Functions | |||
Formula Modification | Excel Discussion (Misc queries) | |||
Modification of a .CSV file | Excel Discussion (Misc queries) | |||
last modification | Excel Discussion (Misc queries) | |||
Formula Modification Help | Excel Worksheet Functions |