See attached.
Currently i have =IF(ISBLANK(C2),"",C2)
However, i need it to also read that if C2 is blank, but B2 is not blank, it needs to read B2*1000
See attached.
Currently i have =IF(ISBLANK(C2),"",C2)
However, i need it to also read that if C2 is blank, but B2 is not blank, it needs to read B2*1000
D2
=if(c2<>"",c2,if(b2<>"",b2*1000,""))
Quang PT
Please try in D2 copied down:
Formula:Please Login or Register to view this content.
Last edited by GeoffW283; 09-16-2020 at 11:25 PM. Reason: Missed the *1000 until I saw previous post
Geoff
Did I help significantly? If you wish, click on * Add Reputation to say thanks.
If your problem has been resolved please select ?Solved? from the Thread Tools menu
Hi
D2
=IF(AND(ISBLANK(B2),ISBLANK(C2)),"", IF(AND(ISBLANK(B2)=FALSE,ISBLANK(C2)),B2*1000, C2))
Christopher Yap
Just to add my 2c's worth...
=if(and(c2="",b2=""),"",b2*1000)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
D2 cell formula
HTML Code:
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks