LinkBack URL
About LinkBacks
Hello, I'm trying to create a simple IF formula as follows. If cell D19 is blank or zero then I want the same for cell F19. However if D19 is 1 then I want cell F19 to be 20.
Thanks in advance.
Hello, I'm trying to create a simple IF formula as follows. If cell D19 is blank or zero then I want the same for cell F19. However if D19 is 1 then I want cell F19 to be 20.
Thanks in advance.
=if(d19="","",if(d19=0,0,if(d19=1,20,""))) ???
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Please Login or Register to view this content.
Works perfect, Thank you for the help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks