gmooney
Active Member
- Joined
- Oct 21, 2004
- Messages
- 252
- Office Version
- 365
- Platform
- Windows
Hello,
Hopefully Simple question here:
I have a formula in cell D18 that basically states the following:
=IF(Display1!$D$71=1,'Budget Data'!F10,IF(Display1!$D$71=2,'Budget Data'!F11,'Budget Data'!F12))
F10, F11, and F12 are all currently formatted as Number, Currency no decimal and currency 2 decimal.
I want cell D18 to be formatted as whatever the formula returns from the correct cell format of F10, F11, or F12?
Any suggestions?
Hopefully Simple question here:
I have a formula in cell D18 that basically states the following:
=IF(Display1!$D$71=1,'Budget Data'!F10,IF(Display1!$D$71=2,'Budget Data'!F11,'Budget Data'!F12))
F10, F11, and F12 are all currently formatted as Number, Currency no decimal and currency 2 decimal.
I want cell D18 to be formatted as whatever the formula returns from the correct cell format of F10, F11, or F12?
Any suggestions?